APPS.BOM_IMPORT_PUB dependencies on BOM_STRUCTURES_B

Line 101: FROM bom_structures_b

97:
98: CURSOR Get_Bill_Details
99: IS
100: SELECT bill_sequence_id
101: FROM bom_structures_b
102: WHERE assembly_item_id = p_parent_id
103: AND organization_id = p_org_id
104: AND nvl(alternate_bom_designator,'Primary') = nvl(p_str_name,'Primary');
105:

Line 110: FROM bom_structures_b

106: BEGIN
107:
108: SELECT bill_sequence_id
109: INTO l_bill_seq_id
110: FROM bom_structures_b
111: WHERE assembly_item_id = p_parent_id
112: AND organization_id = p_org_id
113: AND nvl(alternate_bom_designator,'Primary') = nvl(p_str_name,'Primary');
114:

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

280: BEGIN
281:
282: SELECT item_number
283: INTO l_temp
284: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
285: WHERE BBMI.batch_id = p_batch_id
286: AND BSB.bill_sequence_id = p_bill_seq_id
287: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
288: 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 1315: bom_Structures_b BSB

1311: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)
1312: IS
1313: SELECT BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
1314: FROM bom_bill_of_mtls_interface BBMI,
1315: bom_Structures_b BSB
1316: WHERE BBMI.batch_id = l_batch_id
1317: AND process_flag NOT IN(3,7,-1)
1318: AND BSB.assembly_item_id = l_item_id
1319: AND BSB.organization_id = l_org_id

Line 3067: FROM bom_structures_b

3063:
3064: /*IF l_bill_seq_id IS NOT NULL THEN
3065: SELECT assembly_item_id,organization_id
3066: INTO l_parent_id,l_org_id
3067: FROM bom_structures_b
3068: WHERE bill_sequence_id = l_bill_seq_id;*/
3069: IF p_parent_id IS NOT NULL AND p_org_id IS NOT NULL THEN
3070: 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);
3071: END IF;

Line 4131: bom_Structures_b BSB

4127: SELECT
4128: BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
4129: FROM
4130: bom_bill_of_mtls_interface BBMI,
4131: bom_Structures_b BSB
4132: WHERE
4133: BBMI.batch_id = l_batch_id
4134: AND BBMI.process_flag NOT IN (3,7,-1,0)
4135: AND BSB.assembly_item_id = l_item_id