APPS.POS_ASN dependencies on PO_HEADERS

Line 75: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'

71:
72: select rowidtochar(ROWID)
73: into p_rowid
74: from AK_FLOW_REGION_RELATIONS
75: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
76: and FROM_REGION_APPL_ID = 178
77: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
78: and FROM_PAGE_APPL_ID = 178
79: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'

Line 77: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'

73: into p_rowid
74: from AK_FLOW_REGION_RELATIONS
75: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
76: and FROM_REGION_APPL_ID = 178
77: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
78: and FROM_PAGE_APPL_ID = 178
79: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
80: and TO_PAGE_APPL_ID = 178
81: and FLOW_CODE = 'ICX_INQUIRIES'

Line 79: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'

75: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
76: and FROM_REGION_APPL_ID = 178
77: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
78: and FROM_PAGE_APPL_ID = 178
79: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
80: and TO_PAGE_APPL_ID = 178
81: and FLOW_CODE = 'ICX_INQUIRIES'
82: and FLOW_APPLICATION_ID = 178;
83:

Line 86: from po_headers

82: and FLOW_APPLICATION_ID = 178;
83:
84: select po_header_id
85: into header_id
86: from po_headers
87: where TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT') and
88: segment1 = decode(instrb(seg1,'-'), 0, seg1, substr(seg1, 1, (instrb(seg1,'-')-1)));
89:
90: l_param := icx_on_utilities.buildOracleONstring(p_rowid => p_rowid,