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_SCRAP_INCR_PKG dependencies on STANDARD

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

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

Line 35: WIP_DISCRETE_STANDARD_JOB CONSTANT NUMBER:= 1;

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

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

422: -- Note also that the inner query groups on mmt.transaction_id.
423: -- This is to ensure that all MTA rows for an MMT entry are
424: -- summed before quantity is summed, else we miscount quantity.
425: --
426: -- In addition, exclude all non standard discrete jobs. Discrete jobs
427: -- have an entity_type = 1 and standard jobs have a job_type = 1.
428: -- entity_type and job_type are both not null columns, so it is safe
429: -- to outer join and NVL to them.
430: --

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

423: -- This is to ensure that all MTA rows for an MMT entry are
424: -- summed before quantity is summed, else we miscount quantity.
425: --
426: -- In addition, exclude all non standard discrete jobs. Discrete jobs
427: -- have an entity_type = 1 and standard jobs have a job_type = 1.
428: -- entity_type and job_type are both not null columns, so it is safe
429: -- to outer join and NVL to them.
430: --
431: -- Because of OSFM etc. we pick only the following types of jobs:

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

493: WIP_REPETITIVE_ASSEMBLY_JOB,
494: WIP_CLOSED_DISCRETE_JOB,
495: WIP_FLOW_SCHEDULE_JOB)
496: AND wdj.wip_entity_id(+) = we.wip_entity_id
497: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =
498: WIP_DISCRETE_STANDARD_JOB
499: GROUP BY mmt.organization_id,
500: mmt.inventory_item_id,
501: trunc (mmt.transaction_date),

Line 498: WIP_DISCRETE_STANDARD_JOB

494: WIP_CLOSED_DISCRETE_JOB,
495: WIP_FLOW_SCHEDULE_JOB)
496: AND wdj.wip_entity_id(+) = we.wip_entity_id
497: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =
498: WIP_DISCRETE_STANDARD_JOB
499: GROUP BY mmt.organization_id,
500: mmt.inventory_item_id,
501: trunc (mmt.transaction_date),
502: mmt.primary_quantity,