APPS.PO_UDA_TEMPLATES_UTIL dependencies on PO_HEADERS_ALL

Line 1061: FROM PO_HEADERS_ALL

1057:
1058: IF l_entity_code = 'PO_HEADER_EXT_ATTRS' THEN
1059: SELECT count(*)
1060: INTO l_count
1061: FROM PO_HEADERS_ALL
1062: WHERE UDA_TEMPLATE_ID = l_template_id;
1063: END IF;
1064: IF l_entity_code = 'PO_LINE_EXT_ATTRS' THEN
1065: SELECT count(*)

Line 3567: FROM PO_HEADERS_ALL_EXT_VL pkt0 , PO_HEADERS_ALL tbl , PO_HEADERS_ALL_EXT_VL pkt1

3563: cotroffice_phone, paymentoffice_address, paymentoffice_contact, paymentoffice_email, paymentoffice_location, paymentoffice_phone)
3564: AS
3565: ( SELECT tbl.PO_HEADER_ID , pkt0.C_EXT_ATTR2 , pkt0.C_EXT_ATTR3 , pkt0.C_EXT_ATTR5 , pkt0.C_EXT_ATTR1 , pkt0.C_EXT_ATTR4 ,
3566: pkt1.C_EXT_ATTR2 , pkt1.C_EXT_ATTR3 , pkt1.C_EXT_ATTR5 , pkt1.C_EXT_ATTR1 , pkt1.C_EXT_ATTR4
3567: FROM PO_HEADERS_ALL_EXT_VL pkt0 , PO_HEADERS_ALL tbl , PO_HEADERS_ALL_EXT_VL pkt1
3568: WHERE pkt0.attr_group_id (+) = 1734 AND tbl.PO_HEADER_ID = pkt0.PO_HEADER_ID (+) AND pkt0.pk1_value is NULL
3569: AND pkt1.attr_group_id (+) = 1740 AND tbl.PO_HEADER_ID = pkt1.PO_HEADER_ID (+) AND pkt1.pk1_value is NULL )
3570: */
3571: PROCEDURE get_query_for_temp_view