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.CST_PENDINGTXNSREPORT_PVT dependencies on MFG_LOOKUPS

Line 462: l_resolution_type MFG_LOOKUPS.MEANING%TYPE;

458: l_xml_temp CLOB;
459: l_offset PLS_INTEGER;
460: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
461: l_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;
462: l_resolution_type MFG_LOOKUPS.MEANING%TYPE;
463: l_temp VARCHAR2(240);
464: l_stmt_num NUMBER;
465:
466: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;

Line 518: FROM MFG_LOOKUPS ml

514:
515: l_stmt_num := 25;
516: SELECT ML.MEANING
517: INTO l_resolution_type
518: FROM MFG_LOOKUPS ml
519: WHERE ml.lookup_type = 'CST_SRS_RESOLUTION_TYPES'
520: AND ml.lookup_code = i_resolution_type;
521:
522: /* Open Ref Cursor */

Line 530: FROM MFG_LOOKUPS ml

526: 'SELECT :l_org_code ORG_CODE,
527: :l_period_name PERIOD_NAME,
528: :l_resolution_type RESOLUTION_TYPE,
529: ml.meaning TXN_TYPE
530: FROM MFG_LOOKUPS ml
531: WHERE ml.lookup_type = ''CST_SRS_TRANSACTION_TYPES''
532: AND ml.lookup_code = :i_transaction_type'
533: USING l_org_code, l_period_name, l_resolution_type, i_transaction_type;
534:

Line 701: MFG_LOOKUPS ml,

697: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
698: MTL_ITEM_FLEXFIELDS mif,
699: MTL_TRANSACTION_TYPES mtt,
700: MTL_TXN_SOURCE_TYPES mtst,
701: MFG_LOOKUPS ml,
702: MFG_LOOKUPS ml1,
703: MTL_TRANSACTION_LOTS_TEMP mtlt,
704: MTL_SERIAL_NUMBERS_TEMP msnt
705: WHERE mmtt.organization_id = :i_org_id

Line 702: MFG_LOOKUPS ml1,

698: MTL_ITEM_FLEXFIELDS mif,
699: MTL_TRANSACTION_TYPES mtt,
700: MTL_TXN_SOURCE_TYPES mtst,
701: MFG_LOOKUPS ml,
702: MFG_LOOKUPS ml1,
703: MTL_TRANSACTION_LOTS_TEMP mtlt,
704: MTL_SERIAL_NUMBERS_TEMP msnt
705: WHERE mmtt.organization_id = :i_org_id
706: AND mmtt.transaction_date <= :i_period_end_date

Line 1035: mfg_lookups ml,

1031: FROM wip_cost_txn_interface wcti,
1032: wip_txn_interface_errors wtie,
1033: mtl_item_flexfields mif,
1034: bom_resources br,
1035: mfg_lookups ml,
1036: mfg_lookups ml1,
1037: mfg_lookups ml2
1038: WHERE wcti.organization_id = :i_org_id
1039: AND transaction_date <= :i_period_end_date

Line 1036: mfg_lookups ml1,

1032: wip_txn_interface_errors wtie,
1033: mtl_item_flexfields mif,
1034: bom_resources br,
1035: mfg_lookups ml,
1036: mfg_lookups ml1,
1037: mfg_lookups ml2
1038: WHERE wcti.organization_id = :i_org_id
1039: AND transaction_date <= :i_period_end_date
1040: AND wtie.transaction_id (+) = wcti.transaction_id

Line 1037: mfg_lookups ml2

1033: mtl_item_flexfields mif,
1034: bom_resources br,
1035: mfg_lookups ml,
1036: mfg_lookups ml1,
1037: mfg_lookups ml2
1038: WHERE wcti.organization_id = :i_org_id
1039: AND transaction_date <= :i_period_end_date
1040: AND wtie.transaction_id (+) = wcti.transaction_id
1041: AND wcti.organization_id = mif.organization_id (+)

Line 1195: mfg_lookups ml,

1191: wsmti.ERROR_MESSAGE
1192: FROM wsm_split_merge_txn_interface wsmti,
1193: wsm_starting_jobs_interface wsji,
1194: wsm_resulting_jobs_interface wrji,
1195: mfg_lookups ml,
1196: mfg_lookups ml1
1197: WHERE wsmti.header_id = wsji.header_id(+)
1198: AND wsmti.header_id = wrji.header_id(+)
1199: AND ml.lookup_type = ''WSM_WIP_LOT_TXN_TYPE''

Line 1196: mfg_lookups ml1

1192: FROM wsm_split_merge_txn_interface wsmti,
1193: wsm_starting_jobs_interface wsji,
1194: wsm_resulting_jobs_interface wrji,
1195: mfg_lookups ml,
1196: mfg_lookups ml1
1197: WHERE wsmti.header_id = wsji.header_id(+)
1198: AND wsmti.header_id = wrji.header_id(+)
1199: AND ml.lookup_type = ''WSM_WIP_LOT_TXN_TYPE''
1200: AND ml.lookup_code = wsmti.transaction_type_id

Line 1277: mfg_lookups ml

1273: wlmti.HEADER_ID,
1274: wlmti.REASON_NAME
1275: FROM wsm_lot_move_txn_interface wlmti,
1276: mtl_item_flexfields mif,
1277: mfg_lookups ml
1278: WHERE wlmti.organization_id = :i_org_id
1279: AND wlmti.transaction_date <= :i_period_end_date
1280: AND wlmti.status <> 4
1281: AND NVL(wlmti.primary_item_id, -1) = mif.inventory_item_id(+)

Line 1343: mfg_lookups ml,

1339: wsli.lot_number) reference_lot
1340: FROM wsm_lot_split_merges_interface wlsmi,
1341: wsm_starting_lots_interface wsli,
1342: wsm_resulting_lots_interface wrli,
1343: mfg_lookups ml,
1344: mfg_lookups ml1
1345: WHERE wlsmi.organization_id = :i_org_id
1346: AND ml.lookup_type = ''WSM_INV_LOT_TXN_TYPE''
1347: AND ml.lookup_code = wlsmi.transaction_type_id

Line 1344: mfg_lookups ml1

1340: FROM wsm_lot_split_merges_interface wlsmi,
1341: wsm_starting_lots_interface wsli,
1342: wsm_resulting_lots_interface wrli,
1343: mfg_lookups ml,
1344: mfg_lookups ml1
1345: WHERE wlsmi.organization_id = :i_org_id
1346: AND ml.lookup_type = ''WSM_INV_LOT_TXN_TYPE''
1347: AND ml.lookup_code = wlsmi.transaction_type_id
1348: AND ml1.lookup_type = ''WIP_PROCESS_STATUS''

Line 1552: mfg_lookups ml1,

1548: mtl_item_flexfields mif,
1549: mtl_serial_numbers_interface msni,
1550: mtl_transaction_lots_interface mtli,
1551: mtl_parameters mp,
1552: mfg_lookups ml1,
1553: mfg_lookups ml2,
1554: mfg_lookups ml3,
1555: mfg_lookups ml4,
1556: mtl_txn_source_types mtst,

Line 1553: mfg_lookups ml2,

1549: mtl_serial_numbers_interface msni,
1550: mtl_transaction_lots_interface mtli,
1551: mtl_parameters mp,
1552: mfg_lookups ml1,
1553: mfg_lookups ml2,
1554: mfg_lookups ml3,
1555: mfg_lookups ml4,
1556: mtl_txn_source_types mtst,
1557: mtl_transaction_types mtt

Line 1554: mfg_lookups ml3,

1550: mtl_transaction_lots_interface mtli,
1551: mtl_parameters mp,
1552: mfg_lookups ml1,
1553: mfg_lookups ml2,
1554: mfg_lookups ml3,
1555: mfg_lookups ml4,
1556: mtl_txn_source_types mtst,
1557: mtl_transaction_types mtt
1558: WHERE mti.organization_id = :i_org_id

Line 1555: mfg_lookups ml4,

1551: mtl_parameters mp,
1552: mfg_lookups ml1,
1553: mfg_lookups ml2,
1554: mfg_lookups ml3,
1555: mfg_lookups ml4,
1556: mtl_txn_source_types mtst,
1557: mtl_transaction_types mtt
1558: WHERE mti.organization_id = :i_org_id
1559: AND mti.transaction_date <= :i_period_end_date

Line 2286: FROM mfg_lookups

2282: wdj.SCHEDULED_COMPLETION_DATE,
2283: pjm_project.all_proj_idtoname(wdj.project_id) PROJECT_NAME,
2284: pjm_project.all_task_idtoname(wdj.task_id) TASK_NAME,
2285: (SELECT meaning
2286: FROM mfg_lookups
2287: WHERE lookup_code = wdj.activity_type
2288: AND lookup_type = ''MTL_EAM_ACTIVITY_TYPE'') ACTIVITY_TYPE_DISP,
2289: (SELECT meaning
2290: FROM mfg_lookups

Line 2290: FROM mfg_lookups

2286: FROM mfg_lookups
2287: WHERE lookup_code = wdj.activity_type
2288: AND lookup_type = ''MTL_EAM_ACTIVITY_TYPE'') ACTIVITY_TYPE_DISP,
2289: (SELECT meaning
2290: FROM mfg_lookups
2291: WHERE lookup_code = wdj.activity_cause
2292: AND lookup_type = ''MTL_EAM_ACTIVITY_CAUSE'') ACTIVITY_CAUSE_DISP,
2293: (SELECT meaning
2294: FROM mfg_lookups

Line 2294: FROM mfg_lookups

2290: FROM mfg_lookups
2291: WHERE lookup_code = wdj.activity_cause
2292: AND lookup_type = ''MTL_EAM_ACTIVITY_CAUSE'') ACTIVITY_CAUSE_DISP,
2293: (SELECT meaning
2294: FROM mfg_lookups
2295: WHERE lookup_code = wdj.activity_source
2296: AND lookup_type = ''MTL_EAM_ACTIVITY_SOURCE'') ACTIVITY_SOURCE_MEANING,
2297: cii.serial_number ASSET_SERIAL_NUMBER,
2298: (SELECT meaning

Line 2299: FROM mfg_lookups

2295: WHERE lookup_code = wdj.activity_source
2296: AND lookup_type = ''MTL_EAM_ACTIVITY_SOURCE'') ACTIVITY_SOURCE_MEANING,
2297: cii.serial_number ASSET_SERIAL_NUMBER,
2298: (SELECT meaning
2299: FROM mfg_lookups
2300: WHERE lookup_code = wdj.work_order_type
2301: AND lookup_type = ''WIP_EAM_WORK_ORDER_TYPE'') WORK_ORDER_TYPE_DISP,
2302: wdj.DATE_RELEASED,
2303: wdj.DATE_COMPLETED,

Line 2469: mfg_lookups ml

2465: err.error_message
2466: FROM cst_lc_adj_interface clai,
2467: cst_lc_adj_interface_errors err,
2468: mtl_item_flexfields mif,
2469: mfg_lookups ml
2470: WHERE clai.organization_id = :i_org_id
2471: AND transaction_date <= :i_period_end_date
2472: AND err.transaction_id (+) = clai.transaction_id
2473: AND clai.organization_id = mif.organization_id (+)