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