[Home] [Help]
1149: p_event_spec_disp_id IN NUMBER) IS
1150:
1151: CURSOR c_sample IS
1152: select a.organization_id, b.organization_code, a.sample_no
1153: from gmd_samples a, mtl_parameters b
1154: where sample_id = p_sample_id
1155: and a.organization_id = b.organization_id;
1156:
1157:
1158: CURSOR c_samples IS
1159: select a.organization_id, c.organization_code, a.sample_no
1160: from gmd_samples a,
1161: gmd_event_spec_disp b,
1162: mtl_parameters c
1163: where a.sampling_event_id = b.sampling_event_id
1164: and b.event_spec_disp_id = p_event_spec_disp_id
1165: and a.organization_id = c.organization_id;
1166:
1480: oe_order_lines_all l,
1481: wsh_delivery_details wdd,
1482: wsh_new_deliveries wnd,
1483: wsh_delivery_assignments wda,
1484: mtl_parameters ship_from_org,
1485: mtl_system_items_b_kfv msi, --INVCONV
1486: hz_cust_accounts c,
1487: hz_cust_site_uses_all s,
1488: hz_cust_acct_sites_all a,
1541:
1542: FROM
1543: oe_order_headers_all h,
1544: oe_order_lines_all l,
1545: mtl_parameters ship_from_org,
1546: mtl_system_items_b_kfv msi, --INVCONV
1547: hz_cust_accounts c,
1548: hz_cust_site_uses_all s,
1549: hz_cust_acct_sites_all a,
1568: --INVCONV
1569: /*CURSOR get_whse_info (c_ship_from_org_id oe_order_lines.ship_from_org_id%TYPE) IS
1570: SELECT s.orgn_code,
1571: w.whse_code
1572: FROM mtl_parameters p,
1573: ic_whse_mst w,
1574: sy_orgn_mst s
1575: WHERE w.mtl_organization_id = c_ship_from_org_id
1576: AND p.ORGANIZATION_ID = c_ship_from_org_id