Oracle-EBS

Oracle Process Manufacturing Process Execution  OPM Production Batch GME and INV tables relate together for a given batch The following SQL*Plus queries show how the GME and INV tables relate together for a given batch. In each statement, please replace the value '12345' with the required Batch Number, and 'PR1' with the relevant Plant Code or Organization. 1)  Batch select gbh.* from gme_batch_header gbh where gbh.batch_no = '12345' and gbh.organization_id =   (select organization_id from org_organization_definitions ood     where ood.organization_code = 'PR1');    2) Batch Material Details  select ood.organization_code, gbh.batch_no, gbh.batch_id, gmd.* from gme_material_details gmd, gme_batch_header gbh,  org_organization_definitions ood where gmd.batch_id = gbh.batch_id and gbh.batch_no = '12345' and gbh.organization_id = ood.organization_id and ood.organization_code = 'PR1' order by gbh.batch_id, gmd.material_detail_i; ...

ORG_ACCT_PERIODS holds the open and closed financial periods for organizations. When a period is opened, the period open form (INVTTGPO) pulls in the next available period from the GL table GL_PERIODS.  ORG_ACCT_PERIODS holds the relevant data, such as period start, end and close dates. Note that only postable periods will be brought over. You may create non-postable periods in Oracle General Ledger or in the GL forms provided with Oracle Inventory.  If data exists in the PERIOD_CLOSE_DATE column, then the period has been closed and no more transactions can be made against the closed period. The combination of the PERIOD_CLOSE_DATE and OPEN_FLAG columns reflects the status of a period. When OPEN_FLAG = 'P', it means the period close is processing. When it equals 'N', the period close process is completed. When OPEN_FLAG is 'Y' and PERIOD_CLOSE_DATE is null, it means the period is open. Otherwise, it implies the period close process has failed. Org_Ac...