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,' ||
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,' ||
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,' ||
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 ' ||
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, ' ||
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,
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,
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,
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
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,
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,
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,
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,
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
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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