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 476: l_resolution_type MFG_LOOKUPS.MEANING%TYPE;

472: l_xml_temp CLOB;
473: l_offset PLS_INTEGER;
474: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
475: l_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;
476: l_resolution_type MFG_LOOKUPS.MEANING%TYPE;
477: l_temp VARCHAR2(240);
478: l_stmt_num NUMBER;
479:
480: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;

Line 532: FROM MFG_LOOKUPS ml

528:
529: l_stmt_num := 25;
530: SELECT ML.MEANING
531: INTO l_resolution_type
532: FROM MFG_LOOKUPS ml
533: WHERE ml.lookup_type = 'CST_SRS_RESOLUTION_TYPES'
534: AND ml.lookup_code = i_resolution_type;
535:
536: /* Open Ref Cursor */

Line 544: FROM MFG_LOOKUPS ml

540: 'SELECT :l_org_code ORG_CODE,
541: :l_period_name PERIOD_NAME,
542: :l_resolution_type RESOLUTION_TYPE,
543: ml.meaning TXN_TYPE
544: FROM MFG_LOOKUPS ml
545: WHERE ml.lookup_type = ''CST_SRS_TRANSACTION_TYPES''
546: AND ml.lookup_code = :i_transaction_type'
547: USING l_org_code, l_period_name, l_resolution_type, i_transaction_type;
548:

Line 715: MFG_LOOKUPS ml,

711: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
712: MTL_ITEM_FLEXFIELDS mif,
713: MTL_TRANSACTION_TYPES mtt,
714: MTL_TXN_SOURCE_TYPES mtst,
715: MFG_LOOKUPS ml,
716: MFG_LOOKUPS ml1,
717: MTL_TRANSACTION_LOTS_TEMP mtlt,
718: MTL_SERIAL_NUMBERS_TEMP msnt
719: WHERE mmtt.organization_id = :i_org_id

Line 716: MFG_LOOKUPS ml1,

712: MTL_ITEM_FLEXFIELDS mif,
713: MTL_TRANSACTION_TYPES mtt,
714: MTL_TXN_SOURCE_TYPES mtst,
715: MFG_LOOKUPS ml,
716: MFG_LOOKUPS ml1,
717: MTL_TRANSACTION_LOTS_TEMP mtlt,
718: MTL_SERIAL_NUMBERS_TEMP msnt
719: WHERE mmtt.organization_id = :i_org_id
720: AND mmtt.transaction_date <= :i_period_end_date

Line 1049: mfg_lookups ml,

1045: FROM wip_cost_txn_interface wcti,
1046: wip_txn_interface_errors wtie,
1047: mtl_item_flexfields mif,
1048: bom_resources br,
1049: mfg_lookups ml,
1050: mfg_lookups ml1,
1051: mfg_lookups ml2
1052: WHERE wcti.organization_id = :i_org_id
1053: AND transaction_date <= :i_period_end_date

Line 1050: mfg_lookups ml1,

1046: wip_txn_interface_errors wtie,
1047: mtl_item_flexfields mif,
1048: bom_resources br,
1049: mfg_lookups ml,
1050: mfg_lookups ml1,
1051: mfg_lookups ml2
1052: WHERE wcti.organization_id = :i_org_id
1053: AND transaction_date <= :i_period_end_date
1054: AND wtie.transaction_id (+) = wcti.transaction_id

Line 1051: mfg_lookups ml2

1047: mtl_item_flexfields mif,
1048: bom_resources br,
1049: mfg_lookups ml,
1050: mfg_lookups ml1,
1051: mfg_lookups ml2
1052: WHERE wcti.organization_id = :i_org_id
1053: AND transaction_date <= :i_period_end_date
1054: AND wtie.transaction_id (+) = wcti.transaction_id
1055: AND wcti.organization_id = mif.organization_id (+)

Line 1209: mfg_lookups ml,

1205: wsmti.ERROR_MESSAGE
1206: FROM wsm_split_merge_txn_interface wsmti,
1207: wsm_starting_jobs_interface wsji,
1208: wsm_resulting_jobs_interface wrji,
1209: mfg_lookups ml,
1210: mfg_lookups ml1
1211: WHERE wsmti.header_id = wsji.header_id(+)
1212: AND wsmti.header_id = wrji.header_id(+)
1213: AND ml.lookup_type = ''WSM_WIP_LOT_TXN_TYPE''

Line 1210: mfg_lookups ml1

1206: FROM wsm_split_merge_txn_interface wsmti,
1207: wsm_starting_jobs_interface wsji,
1208: wsm_resulting_jobs_interface wrji,
1209: mfg_lookups ml,
1210: mfg_lookups ml1
1211: WHERE wsmti.header_id = wsji.header_id(+)
1212: AND wsmti.header_id = wrji.header_id(+)
1213: AND ml.lookup_type = ''WSM_WIP_LOT_TXN_TYPE''
1214: AND ml.lookup_code = wsmti.transaction_type_id

Line 1291: mfg_lookups ml

1287: wlmti.HEADER_ID,
1288: wlmti.REASON_NAME
1289: FROM wsm_lot_move_txn_interface wlmti,
1290: mtl_item_flexfields mif,
1291: mfg_lookups ml
1292: WHERE wlmti.organization_id = :i_org_id
1293: AND wlmti.transaction_date <= :i_period_end_date
1294: AND wlmti.status <> 4
1295: AND NVL(wlmti.primary_item_id, -1) = mif.inventory_item_id(+)

Line 1357: mfg_lookups ml,

1353: wsli.lot_number) reference_lot
1354: FROM wsm_lot_split_merges_interface wlsmi,
1355: wsm_starting_lots_interface wsli,
1356: wsm_resulting_lots_interface wrli,
1357: mfg_lookups ml,
1358: mfg_lookups ml1
1359: WHERE wlsmi.organization_id = :i_org_id
1360: AND ml.lookup_type = ''WSM_INV_LOT_TXN_TYPE''
1361: AND ml.lookup_code = wlsmi.transaction_type_id

Line 1358: mfg_lookups ml1

1354: FROM wsm_lot_split_merges_interface wlsmi,
1355: wsm_starting_lots_interface wsli,
1356: wsm_resulting_lots_interface wrli,
1357: mfg_lookups ml,
1358: mfg_lookups ml1
1359: WHERE wlsmi.organization_id = :i_org_id
1360: AND ml.lookup_type = ''WSM_INV_LOT_TXN_TYPE''
1361: AND ml.lookup_code = wlsmi.transaction_type_id
1362: AND ml1.lookup_type = ''WIP_PROCESS_STATUS''

Line 1566: mfg_lookups ml1,

1562: mtl_item_flexfields mif,
1563: mtl_serial_numbers_interface msni,
1564: mtl_transaction_lots_interface mtli,
1565: mtl_parameters mp,
1566: mfg_lookups ml1,
1567: mfg_lookups ml2,
1568: mfg_lookups ml3,
1569: mfg_lookups ml4,
1570: mtl_txn_source_types mtst,

Line 1567: mfg_lookups ml2,

1563: mtl_serial_numbers_interface msni,
1564: mtl_transaction_lots_interface mtli,
1565: mtl_parameters mp,
1566: mfg_lookups ml1,
1567: mfg_lookups ml2,
1568: mfg_lookups ml3,
1569: mfg_lookups ml4,
1570: mtl_txn_source_types mtst,
1571: mtl_transaction_types mtt

Line 1568: mfg_lookups ml3,

1564: mtl_transaction_lots_interface mtli,
1565: mtl_parameters mp,
1566: mfg_lookups ml1,
1567: mfg_lookups ml2,
1568: mfg_lookups ml3,
1569: mfg_lookups ml4,
1570: mtl_txn_source_types mtst,
1571: mtl_transaction_types mtt
1572: WHERE mti.organization_id = :i_org_id

Line 1569: mfg_lookups ml4,

1565: mtl_parameters mp,
1566: mfg_lookups ml1,
1567: mfg_lookups ml2,
1568: mfg_lookups ml3,
1569: mfg_lookups ml4,
1570: mtl_txn_source_types mtst,
1571: mtl_transaction_types mtt
1572: WHERE mti.organization_id = :i_org_id
1573: AND mti.transaction_date <= :i_period_end_date

Line 2300: FROM mfg_lookups

2296: wdj.SCHEDULED_COMPLETION_DATE,
2297: pjm_project.all_proj_idtoname(wdj.project_id) PROJECT_NAME,
2298: pjm_project.all_task_idtoname(wdj.task_id) TASK_NAME,
2299: (SELECT meaning
2300: FROM mfg_lookups
2301: WHERE lookup_code = wdj.activity_type
2302: AND lookup_type = ''MTL_EAM_ACTIVITY_TYPE'') ACTIVITY_TYPE_DISP,
2303: (SELECT meaning
2304: FROM mfg_lookups

Line 2304: FROM mfg_lookups

2300: FROM mfg_lookups
2301: WHERE lookup_code = wdj.activity_type
2302: AND lookup_type = ''MTL_EAM_ACTIVITY_TYPE'') ACTIVITY_TYPE_DISP,
2303: (SELECT meaning
2304: FROM mfg_lookups
2305: WHERE lookup_code = wdj.activity_cause
2306: AND lookup_type = ''MTL_EAM_ACTIVITY_CAUSE'') ACTIVITY_CAUSE_DISP,
2307: (SELECT meaning
2308: FROM mfg_lookups

Line 2308: FROM mfg_lookups

2304: FROM mfg_lookups
2305: WHERE lookup_code = wdj.activity_cause
2306: AND lookup_type = ''MTL_EAM_ACTIVITY_CAUSE'') ACTIVITY_CAUSE_DISP,
2307: (SELECT meaning
2308: FROM mfg_lookups
2309: WHERE lookup_code = wdj.activity_source
2310: AND lookup_type = ''MTL_EAM_ACTIVITY_SOURCE'') ACTIVITY_SOURCE_MEANING,
2311: cii.serial_number ASSET_SERIAL_NUMBER,
2312: (SELECT meaning

Line 2313: FROM mfg_lookups

2309: WHERE lookup_code = wdj.activity_source
2310: AND lookup_type = ''MTL_EAM_ACTIVITY_SOURCE'') ACTIVITY_SOURCE_MEANING,
2311: cii.serial_number ASSET_SERIAL_NUMBER,
2312: (SELECT meaning
2313: FROM mfg_lookups
2314: WHERE lookup_code = wdj.work_order_type
2315: AND lookup_type = ''WIP_EAM_WORK_ORDER_TYPE'') WORK_ORDER_TYPE_DISP,
2316: wdj.DATE_RELEASED,
2317: wdj.DATE_COMPLETED,

Line 2483: mfg_lookups ml

2479: err.error_message
2480: FROM cst_lc_adj_interface clai,
2481: cst_lc_adj_interface_errors err,
2482: mtl_item_flexfields mif,
2483: mfg_lookups ml
2484: WHERE clai.organization_id = :i_org_id
2485: AND transaction_date <= :i_period_end_date
2486: AND err.transaction_id (+) = clai.transaction_id
2487: AND clai.organization_id = mif.organization_id (+)