APPS.BOM_IMPORT_PUB dependencies on BOM_STRUCTURES_B

Line 108: FROM bom_structures_b

104:
105: CURSOR Get_Bill_Details
106: IS
107: SELECT bill_sequence_id
108: FROM bom_structures_b
109: WHERE assembly_item_id = p_parent_id
110: AND organization_id = p_org_id
111: AND nvl(alternate_bom_designator,'Primary') = nvl(p_str_name,'Primary');
112:

Line 117: FROM bom_structures_b

113: BEGIN
114:
115: SELECT bill_sequence_id
116: INTO l_bill_seq_id
117: FROM bom_structures_b
118: WHERE assembly_item_id = p_parent_id
119: AND organization_id = p_org_id
120: AND nvl(alternate_bom_designator,'Primary') = nvl(p_str_name,'Primary');
121:

Line 291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB

287: BEGIN
288:
289: SELECT item_number
290: INTO l_temp
291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
292: WHERE BBMI.batch_id = p_batch_id
293: AND BSB.bill_sequence_id = p_bill_seq_id
294: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
295: AND (( BBMI.request_id IS NOT NULL AND BBMI.request_id = p_request_id ) OR (BBMI.bundle_id IS NOT NULL AND BBMI.bundle_id = p_bundle_id))

Line 1456: bom_Structures_b BSB

1452: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)
1453: IS
1454: SELECT BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
1455: FROM bom_bill_of_mtls_interface BBMI,
1456: bom_Structures_b BSB
1457: WHERE BBMI.batch_id = l_batch_id
1458: AND process_flag NOT IN(3,7,-1)
1459: AND BSB.assembly_item_id = l_item_id
1460: AND BSB.organization_id = l_org_id

Line 3284: FROM bom_structures_b

3280:
3281: /*IF l_bill_seq_id IS NOT NULL THEN
3282: SELECT assembly_item_id,organization_id
3283: INTO l_parent_id,l_org_id
3284: FROM bom_structures_b
3285: WHERE bill_sequence_id = l_bill_seq_id;*/
3286: IF p_parent_id IS NOT NULL AND p_org_id IS NOT NULL THEN
3287: l_par_edit_prvlg := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0,'EGO_EDIT_ITEM','EGO_ITEM',p_parent_id,p_org_id,null,null,null,l_gz_party_id);
3288: END IF;

Line 4523: bom_Structures_b BSB

4519: SELECT
4520: BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
4521: FROM
4522: bom_bill_of_mtls_interface BBMI,
4523: bom_Structures_b BSB
4524: WHERE
4525: BBMI.batch_id = l_batch_id
4526: AND BBMI.process_flag NOT IN (3,7,-1,0)
4527: AND BSB.assembly_item_id = l_item_id