APPS.PO_POXRCPPV_XMLP_PKG dependencies on STANDARD

Line 51: return('AND rct.transaction_id=wt.rcv_transaction_id AND wt.standard_rate_flag=1 '||

47: function where_std_unit_cost return character is
48: wip_status VARCHAR2(1);
49: begin
50: if P_wip_status = 'I' then
51: return('AND rct.transaction_id=wt.rcv_transaction_id AND wt.standard_rate_flag=1 '||
52: 'AND wt.transaction_type = 3 AND exists (select 1 from wip_transaction_accounts wta '||
53: 'where wta.transaction_id = wt.transaction_id and wta.accounting_line_type = 6)' );
54:
55: end if;

Line 65: 'wt.standard_resource_rate * decode(msi.outside_operation_uom_type,'||'''ASSEMBLY'''||', decode(wt.usage_rate_or_amount,0,1,wt.usage_rate_or_amount), 1)');

61: wip_status VARCHAR2(1);
62: begin
63: if P_wip_status = 'I' then
64: return(
65: 'wt.standard_resource_rate * decode(msi.outside_operation_uom_type,'||'''ASSEMBLY'''||', decode(wt.usage_rate_or_amount,0,1,wt.usage_rate_or_amount), 1)');
66: end if;
67:
68: RETURN null;
69: end;