eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_WIP_COMP_INIT_PKG dependencies on STANDARD

Line 32: /* Standard Jobs have Job type of 1 */

28:
29: /* The WIP valuation account is accouting line type 7 */
30: WIP_VALUATION_ACCT CONSTANT NUMBER := 7;
31:
32: /* Standard Jobs have Job type of 1 */
33: WIP_DISCRETE_STANDARD_JOB CONSTANT NUMBER := 1;
34:
35: /* Following entity types need to be collected */
36: WIP_DISCRETE_JOB CONSTANT NUMBER := 1;

Line 33: WIP_DISCRETE_STANDARD_JOB CONSTANT NUMBER := 1;

29: /* The WIP valuation account is accouting line type 7 */
30: WIP_VALUATION_ACCT CONSTANT NUMBER := 7;
31:
32: /* Standard Jobs have Job type of 1 */
33: WIP_DISCRETE_STANDARD_JOB CONSTANT NUMBER := 1;
34:
35: /* Following entity types need to be collected */
36: WIP_DISCRETE_JOB CONSTANT NUMBER := 1;
37: WIP_REPETITIVE_ASSEMBLY_JOB CONSTANT NUMBER := 2;

Line 492: -- In addition, exclude all non standard discrete jobs. Discrete jobs

488: -- Note also that the inner query groups on mmt.transaction_id.
489: -- This is to ensure that all MTA rows for an MMT entry are
490: -- summed before quantity is summed, else we miscount quantity.
491: --
492: -- In addition, exclude all non standard discrete jobs. Discrete jobs
493: -- have an entity_type = 1 and standard jobs have a job_type = 1.
494: -- entity_type and job_type are both not null columns, so it is safe
495: -- to outer join and NVL to them.
496: --

Line 493: -- have an entity_type = 1 and standard jobs have a job_type = 1.

489: -- This is to ensure that all MTA rows for an MMT entry are
490: -- summed before quantity is summed, else we miscount quantity.
491: --
492: -- In addition, exclude all non standard discrete jobs. Discrete jobs
493: -- have an entity_type = 1 and standard jobs have a job_type = 1.
494: -- entity_type and job_type are both not null columns, so it is safe
495: -- to outer join and NVL to them.
496: --
497: -- Because of OSFM etc. we pick only the following types of jobs:

Line 564: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =

560: WIP_REPETITIVE_ASSEMBLY_JOB,
561: WIP_CLOSED_DISCRETE_JOB,
562: WIP_FLOW_SCHEDULE_JOB)
563: AND wdj.wip_entity_id(+) = we.wip_entity_id
564: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =
565: WIP_DISCRETE_STANDARD_JOB
566: GROUP BY mmt.organization_id,
567: mmt.inventory_item_id,
568: trunc (mmt.transaction_date),

Line 565: WIP_DISCRETE_STANDARD_JOB

561: WIP_CLOSED_DISCRETE_JOB,
562: WIP_FLOW_SCHEDULE_JOB)
563: AND wdj.wip_entity_id(+) = we.wip_entity_id
564: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =
565: WIP_DISCRETE_STANDARD_JOB
566: GROUP BY mmt.organization_id,
567: mmt.inventory_item_id,
568: trunc (mmt.transaction_date),
569: mmt.primary_quantity,