APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 572: FROM PO_LINE_LOCATIONS_ALL_EXT_B

568: AND DRAFT_ID = p_draft_id;
569:
570: CURSOR c_po_location_ext(p_location_id NUMBER, p_draft_id NUMBER) IS
571: SELECT DISTINCT ATTR_GROUP_ID
572: FROM PO_LINE_LOCATIONS_ALL_EXT_B
573: WHERE LINE_LOCATION_ID = p_location_id
574: AND DRAFT_ID = p_draft_id;
575:
576: CURSOR c_po_attr_list(p_ag_type VARCHAR2, p_ag_name VARCHAR2) IS

Line 1626: FROM po_Line_locations_all_ext_b

1622:
1623: BEGIN
1624: SELECT 1
1625: INTO l_present
1626: FROM po_Line_locations_all_ext_b
1627: WHERE line_location_id = c_get_shipments_rec.LINE_LOCATION_ID
1628: AND draft_id = l_draft_id
1629: AND ROWNUM < 2;
1630: EXCEPTION

Line 2210: FROM PO_LINE_LOCATIONS_ALL_EXT_B

2206: WHERE PO_LINE_ID = p_line_id;
2207:
2208: CURSOR c_po_location_ext(p_location_id NUMBER) IS
2209: SELECT DISTINCT ATTR_GROUP_ID
2210: FROM PO_LINE_LOCATIONS_ALL_EXT_B
2211: WHERE LINE_LOCATION_ID = p_location_id;
2212:
2213: CURSOR c_po_attr_list(p_ag_type VARCHAR2, p_ag_name VARCHAR2) IS
2214: SELECT END_USER_COLUMN_NAME

Line 2685: FROM PO_LINE_LOCATIONS_all pll

2681: p_po_header_id NUMBER
2682: ,p_line_id NUMBER
2683: )IS
2684: SELECT LINE_LOCATION_ID
2685: FROM PO_LINE_LOCATIONS_all pll
2686: WHERE PO_HEADER_ID = p_po_header_id
2687: AND PO_LINE_ID = p_line_id
2688: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
2689: WHERE act.action_id = actdisp.action_id

Line 2775: FROM PO_LINE_LOCATIONS_all

2771:
2772: BEGIN
2773: SELECT UDA_TEMPLATE_ID
2774: INTO l_shipment_template_id
2775: FROM PO_LINE_LOCATIONS_all
2776: WHERE LINE_LOCATION_ID = c_get_shipments_rec.LINE_LOCATION_ID;
2777:
2778: PO_UDA_DEFAULTING_PKG.DEBUG('Shipment ID is'|| c_get_shipments_rec.LINE_LOCATION_ID, d_progress);
2779: PO_UDA_DEFAULTING_PKG.DEBUG('Template Id for Shipment '|| l_shipment_template_id, d_progress);