APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1181: FROM oe_order_headers_all

1177: IS
1178: --
1179: CURSOR ahl_is_header_deleteable_csr(p_header_id IN NUMBER) IS
1180: SELECT order_type_id
1181: FROM oe_order_headers_all
1182: WHERE header_id = p_header_id
1183: AND booked_flag = 'N';
1184:
1185: CURSOR ahl_is_line_deleteable_csr(p_line_id IN NUMBER) IS

Line 1462: FROM oe_order_headers_all

1458: --Modified by mpothuku on 18-Sep-06 for fixing the Bug 5673483
1459: /*
1460: CURSOR ahl_osp_header_id_csr(p_header_id IN NUMBER) IS
1461: SELECT 1
1462: FROM oe_order_headers_all
1463: WHERE header_id = p_header_id;
1464: */
1465: --
1466: CURSOR ahl_osp_oe_closed_csr(p_header_id IN NUMBER) IS

Line 1468: FROM oe_order_headers_all

1464: */
1465: --
1466: CURSOR ahl_osp_oe_closed_csr(p_header_id IN NUMBER) IS
1467: SELECT open_flag, nvl(flow_status_code,'XXX') flow_status_code, nvl(cancelled_flag,'N') cancelled_flag
1468: FROM oe_order_headers_all
1469: WHERE header_id = p_header_id;
1470: --Modified by mpothuku on 18-Sep-06 for fixing the Bug 5673483
1471: /*
1472: AND open_flag = 'N'

Line 3898: FROM oe_order_headers_all

3894: sold_to_org_id,
3895: sold_from_org_id,
3896: price_list_id,
3897: payment_term_id
3898: FROM oe_order_headers_all
3899: WHERE header_id = p_oe_header_id;
3900:
3901: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3902: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS

Line 5008: OE_ORDER_HEADERS_ALL OE,

5004: SELECT internal_party_id from csi_install_parameters;
5005:
5006: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5007: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5008: OE_ORDER_HEADERS_ALL OE,
5009: oe_order_lines_all OEL
5010: WHERE OEL.line_id = p_oe_line_id AND
5011: OE.HEADER_ID = OEL.HEADER_ID AND
5012: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;

Line 5788: OE_ORDER_HEADERS_ALL OE,

5784: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;
5785:
5786: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5787: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5788: OE_ORDER_HEADERS_ALL OE,
5789: oe_order_lines_all OEL
5790: WHERE OEL.line_id = p_oe_line_id AND
5791: OE.HEADER_ID = OEL.HEADER_ID AND
5792: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;