APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1146: FROM oe_order_headers_all

1142: IS
1143: --
1144: CURSOR ahl_is_header_deleteable_csr(p_header_id IN NUMBER) IS
1145: SELECT order_type_id
1146: FROM oe_order_headers_all
1147: WHERE header_id = p_header_id
1148: AND booked_flag = 'N';
1149:
1150: CURSOR ahl_is_line_deleteable_csr(p_line_id IN NUMBER) IS

Line 1427: FROM oe_order_headers_all

1423: --Modified by mpothuku on 18-Sep-06 for fixing the Bug 5673483
1424: /*
1425: CURSOR ahl_osp_header_id_csr(p_header_id IN NUMBER) IS
1426: SELECT 1
1427: FROM oe_order_headers_all
1428: WHERE header_id = p_header_id;
1429: */
1430: --
1431: CURSOR ahl_osp_oe_closed_csr(p_header_id IN NUMBER) IS

Line 1433: FROM oe_order_headers_all

1429: */
1430: --
1431: CURSOR ahl_osp_oe_closed_csr(p_header_id IN NUMBER) IS
1432: SELECT open_flag, nvl(flow_status_code,'XXX') flow_status_code, nvl(cancelled_flag,'N') cancelled_flag
1433: FROM oe_order_headers_all
1434: WHERE header_id = p_header_id;
1435: --Modified by mpothuku on 18-Sep-06 for fixing the Bug 5673483
1436: /*
1437: AND open_flag = 'N'

Line 3914: FROM oe_order_headers_all

3910: sold_to_org_id,
3911: sold_from_org_id,
3912: price_list_id,
3913: payment_term_id
3914: FROM oe_order_headers_all
3915: WHERE header_id = p_oe_header_id;
3916:
3917: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3918: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS

Line 4963: OE_ORDER_HEADERS_ALL OE,

4959: SELECT internal_party_id from csi_install_parameters;
4960:
4961: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
4962: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
4963: OE_ORDER_HEADERS_ALL OE,
4964: oe_order_lines_all OEL
4965: WHERE OEL.line_id = p_oe_line_id AND
4966: OE.HEADER_ID = OEL.HEADER_ID AND
4967: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;

Line 5743: OE_ORDER_HEADERS_ALL OE,

5739: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;
5740:
5741: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5742: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5743: OE_ORDER_HEADERS_ALL OE,
5744: oe_order_lines_all OEL
5745: WHERE OEL.line_id = p_oe_line_id AND
5746: OE.HEADER_ID = OEL.HEADER_ID AND
5747: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;