DBA Data[Home] [Help]

APPS.OE_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_B

Line 992: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)

988: qp.qp_qualifier_group_no_s.nextval,
989: 'N'
990: --ENH Upgrade BOAPI for orig_sys...ref RAVI
991: ,to_char(QP_QUALIFIERS_S.CURRVAL)
992: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)
993: );
994:
995: END IF;
996:

Line 1111: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.price_list_id)

1107: qp_qualifier_group_no_s.nextval,
1108: 'N'
1109: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1110: ,to_char(QP_QUALIFIERS_S.CURRVAL)
1111: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.price_list_id)
1112: );
1113:
1114: /* create qualifier for secondary price list */
1115:

Line 1152: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)

1148: qp_qualifier_group_no_s.nextval,
1149: 'N'
1150: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1151: ,to_char(QP_QUALIFIERS_S.CURRVAL)
1152: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)
1153: );
1154: END IF;
1155:
1156: