DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PVT dependencies on PO_LINE_LOCS_EXT_DRAFT_DIFF_V

Line 1079: FROM po_line_locs_ext_draft_diff_v

1075: WITH ag_data AS (
1076: SELECT SubStr(col_name, 1,InStr(col_name,'_'||Chr(0))-1) attr_grp_name,
1077: SubStr(col_name, InStr(col_name, Chr(0))+1) attr_name ,
1078: col_value col_value
1079: FROM po_line_locs_ext_draft_diff_v
1080: WHERE col_value IS NOT NULL
1081: ) --Collecting the attribute grp name, aatribute name and their value in ag_data
1082: SELECT ag_data.attr_grp_name, ag_data.attr_name, ag_data.col_value
1083: BULK COLLECT INTO l_attr_grp_tbl, l_attr_name_tbl, l_mod_value_tbl