[Home] [Help]
137: */
138: stmt_num := 2;
139: LOOP
140: UPDATE bom_bill_of_mtls_interface ori
141: SET transaction_id = mtl_system_items_interface_s.nextval,
142: transaction_type = upper(transaction_type),
143: bill_sequence_id = decode(upper(transaction_type), G_Insert,
144: bom_inventory_components_s.nextval,
145: bill_sequence_id)
224: stmt_num := 5.1;
225: DECLARE
226: CURSOR GetBOMItemType IS
227: SELECT bom_item_type
228: FROM mtl_system_items
229: WHERE organization_id = c1rec.OI
230: AND inventory_item_id = c1rec.AII;
231: BEGIN
232: FOR c1 IN GetBOMItemType LOOP
286: nvl(c1rec.CB, user_id),
287: nvl(c1rec.LUL, user_id),
288: sysdate,
289: sysdate,
290: mtl_system_items_interface_s.nextval,
291: 2,
292: G_Insert,
293: req_id,
294: prog_appid,
572: nvl(c1rec.CB, user_id),
573: nvl(c1rec.LUL, user_id),
574: sysdate,
575: sysdate,
576: mtl_system_items_interface_s.nextval,
577: 2,
578: G_Insert,
579: req_id,
580: prog_appid,
701: SELECT bom.bill_sequence_id, bom.assembly_type,
702: msi.bom_item_type
703: INTO c2rec.BSI, c2rec.AST, x_bom_item_type
704: FROM bom_bill_of_materials bom,
705: mtl_system_items msi
706: WHERE bom.organization_id = c2rec.OI
707: AND bom.assembly_item_id = c2rec.AII
708: AND nvl(bom.alternate_bom_designator, 'NONE') =
709: nvl(c2rec.ABD, 'NONE')
743: msi.bom_item_type
744: INTO c2rec.AII, c2rec.OI, c2rec.ABD, c2rec.AST,
745: x_bom_item_type
746: FROM bom_bill_of_materials bom,
747: mtl_system_items msi
748: WHERE bom.bill_sequence_id = c2rec.BSI
749: AND msi.organization_id = bom.organization_id
750: AND msi.inventory_item_id = bom.assembly_item_id;
751: EXCEPTION
1398: -- Get item attributes for the bill
1399: SELECT bom_item_type, base_item_id, replenish_to_order_flag,
1400: pick_components_flag
1401: INTO bit, base_id, ato, pto
1402: FROM mtl_system_items
1403: WHERE inventory_item_id = item_id
1404: AND organization_id = org_id;
1405:
1406: stmt_num := 5;
1409: FROM bom_inventory_components bic
1410: WHERE bic.bill_sequence_id = cmn_bom_id
1411: AND not exists
1412: (SELECT 'x'
1413: FROM mtl_system_items s
1414: WHERE s.organization_id = org_id
1415: AND s.inventory_item_id = bic.component_item_id
1416: AND ((bom_type = 1 AND s.eng_item_flag = 'N')
1417: OR (bom_type = 2))
1462: WHERE bic.bill_sequence_id = cmn_bom_id
1463: AND bic.component_sequence_id = bsc.component_sequence_id
1464: AND bsc.substitute_component_id not in
1465: (select msi1.inventory_item_id
1466: from mtl_system_items msi1, mtl_system_items msi2
1467: where msi1.organization_id = org_id
1468: and msi1.inventory_item_id = bsc.substitute_component_id
1469: and msi2.organization_id = cmn_org_id
1470: and msi2.inventory_item_id = msi1.inventory_item_id);
1481: stmt_num := 7;
1482: BEGIN
1483: SELECT 1
1484: INTO cnt
1485: FROM mtl_system_items msi1, mtl_system_items msi2
1486: WHERE msi1.organization_id = org_id
1487: AND msi1.inventory_item_id = item_id
1488: AND msi2.organization_id = cmn_org_id
1489: AND msi2.inventory_item_id = cmn_item_id
1681: stmt_num := 1.1;
1682: DECLARE
1683: CURSOR GetBOMItemType IS
1684: SELECT bom_item_type
1685: FROM mtl_system_items
1686: WHERE organization_id = c1rec.OI
1687: AND inventory_item_id = c1rec.AII;
1688: BEGIN
1689: FOR c1 IN GetBOMItemType LOOP
1757: stmt_num := 3;
1758: BEGIN
1759: SELECT 1
1760: INTO dummy_id
1761: FROM mtl_system_items
1762: WHERE organization_id = c1rec.OI
1763: AND inventory_item_id = c1rec.AII;
1764: EXCEPTION
1765: WHEN no_data_found THEN
1925: stmt_num := 7;
1926: BEGIN
1927: SELECT 1
1928: INTO dummy_id
1929: FROM mtl_system_items
1930: WHERE organization_id = c1rec.OI
1931: AND inventory_item_id = c1rec.AII
1932: AND bom_enabled_flag = 'Y'
1933: AND ((c1rec.AST = 2)
2092: X_assembly_type, X_common_bill_sequence_id,
2093: X_common_organization_id, X_next_explode_date,
2094: x_bom_item_type
2095: FROM bom_bill_of_materials bom,
2096: mtl_system_items msi
2097: WHERE bill_sequence_id = c2rec.BSI
2098: AND msi.organization_id = bom.organization_id
2099: AND msi.inventory_item_id = bom.assembly_item_id;
2100: EXCEPTION