DBA Data[Home] [Help]

APPS.BOM_BOM_HEADER_UTIL dependencies on BOM_STRUCTURES_B

Line 24: -- bom_structures_b instead of bom_bill_of_materials.

20: -- 19-Aug-2003 Hari Gelli added obj_name, pk1_value, pk2_value in insert_row
21: -- 06-Feb-2004 Vani added Is_Preferred Flag for inserts
22: -- 11-JAN-2005 Vani added effectivity control in Insert_Row
23: -- 21-FEB-2005 Vani added query_table_row method to query from
24: -- bom_structures_b instead of bom_bill_of_materials.
25: -- 06-MAY-2005 Abhsihek Rudresh Common BOM Attrs Update
26: -- 13-JUL-06 Bhavnesh Patel Added support for Structure Type
27: ****************************************************************************/
28:

Line 157: * Purpose : Procedure will query the database record, From BOM_STRUCTURES_B

153: * Parameters OUT: Bom header exposed column record
154: * BOm Header unexposed column record
155: * Mesg token Table
156: * Return Status
157: * Purpose : Procedure will query the database record, From BOM_STRUCTURES_B
158: * seperate the values into exposed columns and unexposed columns and
159: * return with those records.
160: ***********************************************************************/
161: PROCEDURE Query_Table_Row

Line 236: FROM bom_structures_b

232: , l_bom_head_unexp_rec.common_bill_sequence_id
233: , l_bom_head_unexp_rec.bill_sequence_id
234: , l_bom_head_unexp_rec.structure_type_id
235: , l_bom_header_rec.bom_implementation_date
236: FROM bom_structures_b
237: WHERE assembly_item_id = p_assembly_item_id
238: AND organization_id = p_organization_id
239: AND NVL(alternate_bom_designator, 'XXXX') =
240: NVL(DECODE( p_alternate_bom_code,FND_API.G_MISS_CHAR,

Line 613: from bom_structures_b

609: END IF;
610:
611: --bug 5199643
612: select assembly_type into l_assembly_type
613: from bom_structures_b
614: where bill_sequence_id =l_bom_head_unexp_rec.bill_sequence_id;
615:
616: l_dg_sequence_id :=
617: MODAL_DELETE.DELETE_MANAGER