DBA Data[Home] [Help]

APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_ROUTING_HEADER_TEMP

Line 113: FROM bom_routing_header_temp tmp,

109: , NULL Delete_Group_Name
110: , NULL DG_Description
111: , NULL ser_start_op_seq
112: , NULL row_identifier
113: FROM bom_routing_header_temp tmp,
114: mtl_parameters org,
115: mtl_system_items_kfv item
116: WHERE org.organization_code = tmp.OrganizationCode
117: AND item.organization_id = org.organization_id

Line 162: FROM bom_routing_header_temp tmp,

158: , NULL Delete_Group_Name
159: , NULL DG_Description
160: , NULL ser_start_op_seq
161: , NULL row_identifier
162: FROM bom_routing_header_temp tmp,
163: mtl_parameters org,
164: mtl_system_items_kfv item
165: WHERE org.organization_code = tmp.OrganizationCode
166: AND item.organization_id = org.organization_id

Line 844: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_HEADER_TEMP');

840: FND_MESSAGE.SET_NAME('BOM', 'BOM_SETUP_NO_ROWS');
841: FND_MESSAGE.RETRIEVE(X_G_msg_data);
842: ELSE
843: -- get the context handle
844: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_HEADER_TEMP');
845: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
846: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
847: DBMS_XMLSave.setRowTag(insCtx , 'OperationalRoutingsVO');
848: -- this inserts the document