APPS.ENG_BOM_RTG_TRANSFER_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 174: FROM BOM_BILL_OF_MATERIALS BOM

170: CURSOR common_item_csr IS
171: -- Get DISTINCT items. This is only item transfer
172: SELECT DISTINCT NVL(COMMON_ASSEMBLY_ITEM_ID,ASSEMBLY_ITEM_ID) COMMON_ASSEMBLY_ITEM_ID,
173: NVL(COMMON_ORGANIZATION_ID,ORGANIZATION_ID) COMMON_ORG_ID
174: FROM BOM_BILL_OF_MATERIALS BOM
175: WHERE BOM.ORGANIZATION_ID = X_org_id
176: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id
177: AND nvl(bom.effectivity_control, 1) <> 4 -- Bug 4210718
178: AND ((X_designator_option = 2 AND

Line 188: FROM BOM_BILL_OF_MATERIALS RBOM, MTL_SYSTEM_ITEMS_B MST, BOM_BILL_OF_MATERIALS CBOM

184: -- Get DISTINCT items. This is only item transfer Added
185: --AND RBOM.COMMON_BILL_SEQUENCE_ID = NVL(CBOM.COMMON_BILL_SEQUENCE_ID,CBOM.BILL_SEQUENCE_ID)
186: --for performance issue.
187: SELECT DISTINCT RBOM.ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, RBOM.ORGANIZATION_ID ORG_ID
188: FROM BOM_BILL_OF_MATERIALS RBOM, MTL_SYSTEM_ITEMS_B MST, BOM_BILL_OF_MATERIALS CBOM
189: WHERE CBOM.ORGANIZATION_ID = X_org_id
190: AND CBOM.ASSEMBLY_ITEM_ID = X_eng_item_id
191: AND ((X_designator_option = 2 AND
192: CBOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 208: FROM BOM_BILL_OF_MATERIALS BOM

204: -- Cursor will fetch either the source bill or the bill which is not commoned.
205: CURSOR common_bill_csr IS
206: SELECT NVL(COMMON_ASSEMBLY_ITEM_ID,ASSEMBLY_ITEM_ID) COMMON_ASSEMBLY_ITEM_ID, NVL(COMMON_ORGANIZATION_ID,ORGANIZATION_ID) COMMON_ORG_ID,
207: SOURCE_BILL_SEQUENCE_ID, ALTERNATE_BOM_DESIGNATOR
208: FROM BOM_BILL_OF_MATERIALS BOM
209: WHERE BOM.ORGANIZATION_ID = X_org_id
210: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id
211: AND ((X_designator_option = 2 AND
212: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 219: FROM BOM_BILL_OF_MATERIALS BOM

215: OR (X_designator_option = 1));
216: -- Cursor to fetch all the reference bill if the bill to be transfered is common or reference bill.
217: /* CURSOR reference_bill_csr(cp_Common_Org_Id NUMBER, cp_Common_Assembly_Item_Id NUMBER) IS
218: SELECT ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, ORGANIZATION_ID ORG_ID
219: FROM BOM_BILL_OF_MATERIALS BOM
220: WHERE BOM.COMMON_ORGANIZATION_ID = cp_Common_Org_Id
221: AND BOM.COMMON_ASSEMBLY_ITEM_ID = cp_Common_Assembly_Item_Id -- Fix for bug 3519193. Changed the cursor parameter name
222: AND ((X_designator_option = 2 AND
223: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 231: FROM BOM_BILL_OF_MATERIALS BOM

227: AND BOM.BILL_SEQUENCE_ID <> BOM.COMMON_BILL_SEQUENCE_ID; -- Make sure source not fetched
228: */
229: CURSOR other_reference_bill_csr( cp_Source_Bill_Sequence_Id NUMBER, cp_Assembly_Item_Id NUMBER) IS
230: SELECT ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, ORGANIZATION_ID ORG_ID
231: FROM BOM_BILL_OF_MATERIALS BOM
232: WHERE BOM.Source_BILL_SEQUENCE_ID = cp_Source_Bill_Sequence_Id
233: AND BOM.BILL_SEQUENCE_ID <> BOM.Source_BILL_SEQUENCE_ID; -- Make sure source not fetched
234: -- End Bug#3196367.
235: BEGIN