DBA Data[Home] [Help]

APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on FND_GLOBAL

Line 812: 'fnd_global.conc_request_id,' ||

808: 'bbom.alternate_bom_designator,' ||
809: l_quote || 'Y' || l_quote || ',' ||
810: 'mic.category_id,' ||
811: '1,' ||
812: 'fnd_global.conc_request_id,' ||
813: 'fnd_global.prog_appl_id,' ||
814: 'fnd_global.conc_program_id,' ||
815: 'sysdate,' ||
816: 'fnd_global.user_id,' ||

Line 813: 'fnd_global.prog_appl_id,' ||

809: l_quote || 'Y' || l_quote || ',' ||
810: 'mic.category_id,' ||
811: '1,' ||
812: 'fnd_global.conc_request_id,' ||
813: 'fnd_global.prog_appl_id,' ||
814: 'fnd_global.conc_program_id,' ||
815: 'sysdate,' ||
816: 'fnd_global.user_id,' ||
817: 'sysdate,' ||

Line 814: 'fnd_global.conc_program_id,' ||

810: 'mic.category_id,' ||
811: '1,' ||
812: 'fnd_global.conc_request_id,' ||
813: 'fnd_global.prog_appl_id,' ||
814: 'fnd_global.conc_program_id,' ||
815: 'sysdate,' ||
816: 'fnd_global.user_id,' ||
817: 'sysdate,' ||
818: 'fnd_global.user_id,' ||

Line 816: 'fnd_global.user_id,' ||

812: 'fnd_global.conc_request_id,' ||
813: 'fnd_global.prog_appl_id,' ||
814: 'fnd_global.conc_program_id,' ||
815: 'sysdate,' ||
816: 'fnd_global.user_id,' ||
817: 'sysdate,' ||
818: 'fnd_global.user_id,' ||
819: 'sysdate ' ||
820: 'FROM ' ||

Line 818: 'fnd_global.user_id,' ||

814: 'fnd_global.conc_program_id,' ||
815: 'sysdate,' ||
816: 'fnd_global.user_id,' ||
817: 'sysdate,' ||
818: 'fnd_global.user_id,' ||
819: 'sysdate ' ||
820: 'FROM ' ||
821: 'mrp_kanban_plans mkp, ' ||
822: 'mtl_system_items msi, ' ||

Line 1017: fnd_global.conc_request_id,

1013: bbom.alternate_bom_designator,
1014: l_level_count + 1,
1015: NULL, -- set it to NULL and update it next stmt
1016: mic.category_id,
1017: fnd_global.conc_request_id,
1018: fnd_global.prog_appl_id,
1019: fnd_global.conc_program_id,
1020: sysdate,
1021: fnd_global.user_id,

Line 1018: fnd_global.prog_appl_id,

1014: l_level_count + 1,
1015: NULL, -- set it to NULL and update it next stmt
1016: mic.category_id,
1017: fnd_global.conc_request_id,
1018: fnd_global.prog_appl_id,
1019: fnd_global.conc_program_id,
1020: sysdate,
1021: fnd_global.user_id,
1022: sysdate,

Line 1019: fnd_global.conc_program_id,

1015: NULL, -- set it to NULL and update it next stmt
1016: mic.category_id,
1017: fnd_global.conc_request_id,
1018: fnd_global.prog_appl_id,
1019: fnd_global.conc_program_id,
1020: sysdate,
1021: fnd_global.user_id,
1022: sysdate,
1023: fnd_global.user_id,

Line 1021: fnd_global.user_id,

1017: fnd_global.conc_request_id,
1018: fnd_global.prog_appl_id,
1019: fnd_global.conc_program_id,
1020: sysdate,
1021: fnd_global.user_id,
1022: sysdate,
1023: fnd_global.user_id,
1024: sysdate
1025: FROM

Line 1023: fnd_global.user_id,

1019: fnd_global.conc_program_id,
1020: sysdate,
1021: fnd_global.user_id,
1022: sysdate,
1023: fnd_global.user_id,
1024: sysdate
1025: FROM
1026: mtl_kanban_pull_sequences ps,
1027: bom_bill_of_materials bbom,

Line 1134: fnd_global.conc_request_id,

1130: bbom.alternate_bom_designator,
1131: l_level_count + 1,
1132: NULL, -- set it to NULL and update it next stmt
1133: mic.category_id,
1134: fnd_global.conc_request_id,
1135: fnd_global.prog_appl_id,
1136: fnd_global.conc_program_id,
1137: sysdate,
1138: fnd_global.user_id,

Line 1135: fnd_global.prog_appl_id,

1131: l_level_count + 1,
1132: NULL, -- set it to NULL and update it next stmt
1133: mic.category_id,
1134: fnd_global.conc_request_id,
1135: fnd_global.prog_appl_id,
1136: fnd_global.conc_program_id,
1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,

Line 1136: fnd_global.conc_program_id,

1132: NULL, -- set it to NULL and update it next stmt
1133: mic.category_id,
1134: fnd_global.conc_request_id,
1135: fnd_global.prog_appl_id,
1136: fnd_global.conc_program_id,
1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,
1140: fnd_global.user_id,

Line 1138: fnd_global.user_id,

1134: fnd_global.conc_request_id,
1135: fnd_global.prog_appl_id,
1136: fnd_global.conc_program_id,
1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,
1140: fnd_global.user_id,
1141: sysdate
1142: FROM

Line 1140: fnd_global.user_id,

1136: fnd_global.conc_program_id,
1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,
1140: fnd_global.user_id,
1141: sysdate
1142: FROM
1143: mtl_kanban_pull_sequences ps,
1144: bom_bill_of_materials bbom,

Line 1388: fnd_global.conc_request_id,

1384: mllc1.to_locator_id,
1385: l_level_count + 1,
1386: decode(kbn_items.release_kanban_flag, 1, 'Y', 2, 'Y', 'N'),
1387: mic.category_id,
1388: fnd_global.conc_request_id,
1389: fnd_global.prog_appl_id,
1390: fnd_global.conc_program_id,
1391: sysdate,
1392: fnd_global.user_id,

Line 1389: fnd_global.prog_appl_id,

1385: l_level_count + 1,
1386: decode(kbn_items.release_kanban_flag, 1, 'Y', 2, 'Y', 'N'),
1387: mic.category_id,
1388: fnd_global.conc_request_id,
1389: fnd_global.prog_appl_id,
1390: fnd_global.conc_program_id,
1391: sysdate,
1392: fnd_global.user_id,
1393: sysdate,

Line 1390: fnd_global.conc_program_id,

1386: decode(kbn_items.release_kanban_flag, 1, 'Y', 2, 'Y', 'N'),
1387: mic.category_id,
1388: fnd_global.conc_request_id,
1389: fnd_global.prog_appl_id,
1390: fnd_global.conc_program_id,
1391: sysdate,
1392: fnd_global.user_id,
1393: sysdate,
1394: fnd_global.user_id,

Line 1392: fnd_global.user_id,

1388: fnd_global.conc_request_id,
1389: fnd_global.prog_appl_id,
1390: fnd_global.conc_program_id,
1391: sysdate,
1392: fnd_global.user_id,
1393: sysdate,
1394: fnd_global.user_id,
1395: sysdate
1396: FROM

Line 1394: fnd_global.user_id,

1390: fnd_global.conc_program_id,
1391: sysdate,
1392: fnd_global.user_id,
1393: sysdate,
1394: fnd_global.user_id,
1395: sysdate
1396: FROM
1397: mtl_item_categories mic,
1398: mtl_kanban_pull_sequences kbn_items,

Line 1479: fnd_global.conc_request_id,

1475: ps.source_type,
1476: ps.replenishment_lead_time,
1477: 'Y',
1478: mllc.component_category_id,
1479: fnd_global.conc_request_id,
1480: fnd_global.prog_appl_id,
1481: fnd_global.conc_program_id,
1482: sysdate,
1483: fnd_global.user_id,

Line 1480: fnd_global.prog_appl_id,

1476: ps.replenishment_lead_time,
1477: 'Y',
1478: mllc.component_category_id,
1479: fnd_global.conc_request_id,
1480: fnd_global.prog_appl_id,
1481: fnd_global.conc_program_id,
1482: sysdate,
1483: fnd_global.user_id,
1484: sysdate,

Line 1481: fnd_global.conc_program_id,

1477: 'Y',
1478: mllc.component_category_id,
1479: fnd_global.conc_request_id,
1480: fnd_global.prog_appl_id,
1481: fnd_global.conc_program_id,
1482: sysdate,
1483: fnd_global.user_id,
1484: sysdate,
1485: fnd_global.user_id,

Line 1483: fnd_global.user_id,

1479: fnd_global.conc_request_id,
1480: fnd_global.prog_appl_id,
1481: fnd_global.conc_program_id,
1482: sysdate,
1483: fnd_global.user_id,
1484: sysdate,
1485: fnd_global.user_id,
1486: sysdate
1487: FROM mtl_kanban_pull_sequences ps,

Line 1485: fnd_global.user_id,

1481: fnd_global.conc_program_id,
1482: sysdate,
1483: fnd_global.user_id,
1484: sysdate,
1485: fnd_global.user_id,
1486: sysdate
1487: FROM mtl_kanban_pull_sequences ps,
1488: mrp_low_level_codes mllc
1489: WHERE ps.source_type = 3 -- only intra org replenishments