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 1018: fnd_global.conc_request_id,

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

Line 1019: fnd_global.prog_appl_id,

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

Line 1020: fnd_global.conc_program_id,

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

Line 1022: fnd_global.user_id,

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

Line 1024: fnd_global.user_id,

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

Line 1135: fnd_global.conc_request_id,

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

Line 1136: fnd_global.prog_appl_id,

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

Line 1137: fnd_global.conc_program_id,

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

Line 1139: fnd_global.user_id,

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

Line 1141: fnd_global.user_id,

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

Line 1389: fnd_global.conc_request_id,

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

Line 1390: fnd_global.prog_appl_id,

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

Line 1391: fnd_global.conc_program_id,

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

Line 1393: fnd_global.user_id,

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

Line 1395: fnd_global.user_id,

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

Line 1480: fnd_global.conc_request_id,

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

Line 1481: fnd_global.prog_appl_id,

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

Line 1482: fnd_global.conc_program_id,

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

Line 1484: fnd_global.user_id,

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

Line 1486: fnd_global.user_id,

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