[Home] [Help]
1220: p_event_spec_disp_id IN NUMBER) IS
1221:
1222: CURSOR c_sample IS
1223: select a.organization_id, b.organization_code, a.sample_no
1224: from gmd_samples a, mtl_parameters b
1225: where sample_id = p_sample_id
1226: and a.organization_id = b.organization_id;
1227:
1228:
1229: CURSOR c_samples IS
1230: select a.organization_id, c.organization_code, a.sample_no
1231: from gmd_samples a,
1232: gmd_event_spec_disp b,
1233: mtl_parameters c
1234: where a.sampling_event_id = b.sampling_event_id
1235: and b.event_spec_disp_id = p_event_spec_disp_id
1236: and a.organization_id = c.organization_id;
1237:
1572: oe_order_lines_all l,
1573: wsh_delivery_details wdd,
1574: wsh_new_deliveries wnd,
1575: wsh_delivery_assignments wda,
1576: mtl_parameters ship_from_org,
1577: mtl_system_items_b_kfv msi, --INVCONV
1578: hz_cust_accounts c,
1579: hz_cust_site_uses_all s,
1580: hz_cust_acct_sites_all a,
1655: oe_order_lines_all l,
1656: wsh_delivery_details wdd,
1657: wsh_new_deliveries wnd,
1658: wsh_delivery_assignments wda,
1659: mtl_parameters ship_from_org,
1660: mtl_system_items_b_kfv msi, --INVCONV
1661: hz_cust_accounts c,
1662: hz_cust_site_uses_all s,
1663: hz_cust_acct_sites_all a,
1717:
1718: FROM
1719: oe_order_headers_all h,
1720: oe_order_lines_all l,
1721: mtl_parameters ship_from_org,
1722: mtl_system_items_b_kfv msi, --INVCONV
1723: hz_cust_accounts c,
1724: hz_cust_site_uses_all s,
1725: hz_cust_acct_sites_all a,
1744: --INVCONV
1745: /*CURSOR get_whse_info (c_ship_from_org_id oe_order_lines.ship_from_org_id%TYPE) IS
1746: SELECT s.orgn_code,
1747: w.whse_code
1748: FROM mtl_parameters p,
1749: ic_whse_mst w,
1750: sy_orgn_mst s
1751: WHERE w.mtl_organization_id = c_ship_from_org_id
1752: AND p.ORGANIZATION_ID = c_ship_from_org_id