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

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

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

Line 37: WIP_DISCRETE_STANDARD_JOB CONSTANT NUMBER:= 1;

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

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

455: -- Note also that the inner query groups on mmt.transaction_id.
456: -- This is to ensure that all MTA rows for an MMT entry are
457: -- summed before quantity is summed, else we miscount quantity.
458: --
459: -- In addition, exclude all non standard discrete jobs. Discrete jobs
460: -- have an entity_type = 1 and standard jobs have a job_type = 1.
461: -- entity_type and job_type are both not null columns, so it is safe
462: -- to outer join and NVL to them.
463: --

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

456: -- This is to ensure that all MTA rows for an MMT entry are
457: -- summed before quantity is summed, else we miscount quantity.
458: --
459: -- In addition, exclude all non standard discrete jobs. Discrete jobs
460: -- have an entity_type = 1 and standard jobs have a job_type = 1.
461: -- entity_type and job_type are both not null columns, so it is safe
462: -- to outer join and NVL to them.
463: --
464: -- Because of OSFM etc. we pick only the following types of jobs:

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

527: WIP_REPETITIVE_ASSEMBLY_JOB,
528: WIP_CLOSED_DISCRETE_JOB,
529: WIP_FLOW_SCHEDULE_JOB)
530: AND wdj.wip_entity_id (+) = we.wip_entity_id
531: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =
532: WIP_DISCRETE_STANDARD_JOB
533: GROUP BY mmt.organization_id,
534: mmt.inventory_item_id,
535: trunc (mmt.transaction_date),

Line 532: WIP_DISCRETE_STANDARD_JOB

528: WIP_CLOSED_DISCRETE_JOB,
529: WIP_FLOW_SCHEDULE_JOB)
530: AND wdj.wip_entity_id (+) = we.wip_entity_id
531: AND nvl (wdj.job_type, WIP_DISCRETE_STANDARD_JOB) =
532: WIP_DISCRETE_STANDARD_JOB
533: GROUP BY mmt.organization_id,
534: mmt.inventory_item_id,
535: trunc (mmt.transaction_date),
536: mmt.primary_quantity,