eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PMI_SALES_PKG dependencies on IC_ITEM_MST

Line 10: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,

6: FUNCTION PMISA_GET_TOP_N(p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
7: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
8: p_Prd_start_date IN DATE,
9: p_Prd_end_date IN DATE,
10: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,
11: P_customer_id IN op_ordr_hdr.billcust_id%TYPE DEFAULT NULL,
12: p_top_n IN NUMBER
13: )
14: RETURN NUMBER

Line 39: IC_ITEM_MST itemmst

35: orderdetail.exchange_rate,orderdetail.mul_div_sign)) Margin
36: FROM
37: OP_ORDR_HDR orderhdr,
38: OP_ORDR_DTL orderdetail,
39: IC_ITEM_MST itemmst
40: WHERE orderhdr.order_id = orderdetail.order_id
41: AND orderdetail.item_id = itemmst.item_id
42: AND trunc(orderdetail.ACTUAL_SHIPDATE)
43: between p_prd_start_date and p_prd_end_date

Line 69: IC_ITEM_MST itemmst

65: orderdetail.exchange_rate,orderdetail.mul_div_sign)) Margin
66: FROM
67: OP_ORDR_HDR orderhdr,
68: OP_ORDR_DTL orderdetail,
69: IC_ITEM_MST itemmst
70: WHERE orderhdr.order_id = orderdetail.order_id
71: AND orderdetail.item_id = itemmst.item_id
72: AND trunc(orderdetail.ACTUAL_SHIPDATE)
73: between p_prd_start_date and p_prd_end_date

Line 187: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,

183: FUNCTION PMISA_GET_TOP_N_BY_OU(p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
184: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
185: p_Prd_start_date IN DATE,
186: p_Prd_end_date IN DATE,
187: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,
188: P_customer_id IN hz_parties.PARTY_ID%TYPE DEFAULT NULL,
189: p_top_n IN NUMBER
190: )
191: RETURN NUMBER

Line 221: IC_ITEM_MST itemmst,

217: orderdetail.exchange_rate,orderdetail.mul_div_sign) line_Margin
218: FROM
219: OP_ORDR_HDR orderhdr,
220: OP_ORDR_DTL orderdetail,
221: IC_ITEM_MST itemmst,
222: SY_ORGN_MST org,
223: GL_PLCY_MST pol
224: WHERE orderhdr.order_id = orderdetail.order_id
225: AND orderdetail.item_id = itemmst.item_id

Line 261: IC_ITEM_MST itemmst,

257: OE_ORDER_HEADERS_ALL orderhdr,
258: OE_ORDER_LINES_ALL orderdetail,
259: OE_SYSTEM_PARAMETERS_ALL masterorg,
260: MTL_SYSTEM_ITEMS msi,
261: IC_ITEM_MST itemmst,
262: HR_OPERATING_UNITS ou,
263: GL_SETS_OF_BOOKS sob,
264: IC_WHSE_MST fromwhse
265: WHERE

Line 307: IC_ITEM_MST itemmst,

303: orderdetail.exchange_rate,orderdetail.mul_div_sign) line_Margin
304: FROM
305: OP_ORDR_HDR orderhdr,
306: OP_ORDR_DTL orderdetail,
307: IC_ITEM_MST itemmst,
308: SY_ORGN_MST org,
309: GL_PLCY_MST pol
310: WHERE orderhdr.order_id = orderdetail.order_id
311: AND orderdetail.item_id = itemmst.item_id

Line 347: IC_ITEM_MST itemmst,

343: OE_ORDER_HEADERS_ALL orderhdr,
344: OE_ORDER_LINES_ALL orderdetail,
345: OE_SYSTEM_PARAMETERS_ALL masterorg,
346: MTL_SYSTEM_ITEMS msi,
347: IC_ITEM_MST itemmst,
348: HR_OPERATING_UNITS ou,
349: GL_SETS_OF_BOOKS sob,
350: IC_WHSE_MST fromwhse,
351: PMI_HZ_PARTY_V billingcustomer